﻿select 
	a.directoryName 
	,m.OriginalFilename as FileName
	,m.ExternalHtmlSource
from Gs_Album a, Gs_MediaObject m 
where a.albumid = m.fkalbumid and m.MediaObjectId = @ObjectId